The schema holder
As noted in the previous section, a schema holder contains information about the MSS data sources. This information, called the schema of the data source, is a description of its structure, its tables, the fields within its tables, and its indexes.
OpenEdge accesses the schema holder only when it compiles procedures and at the beginning of a run-time session for schema caching (the loading of data definitions into memory). Typically, the schema holder is not accessed during a run-time session after the initial schema caching.
Before an OpenEdge client can access data in the MSS data source, you must create a schema holder and load the required data source definitions into the schema holder. You can then use the Data Dictionary to add OpenEdge database features such as validation expressions and messages.
Figure 1–3 illustrates the schema-loading process.
If you plan to use the DataServer to send SQL statements directly to the data source using only the RUN STORED–PROCEDURE syntax and you do not expect returned data, you need not load data definitions into the schema holder. However, you must do the following:
However, the RDBMS stored procedures also supports s and ProDataSet functionality which does support returning data to the foreign data source. For information on using RUN STORED–PROCEDURE, see Chapter 3, " RDBMS Stored Procedure Details."